PartyAffiliationType

Entity Definition

Logical Name : PartyAffiliationType
Physical Name : CO_TYP_PRTY_AFLN

A type code defining a potential relationship between two Partys that has some meaning to the retailer. The value list is determined by the retailer. PartyAffiliationType may include a wide range of associations like: HOUSEHOLD-CUSTOMER FAMILY-INDIVIDUAL EMPLOYEE-EMPLOYER ONLINE COMMUNITY-PARTICIPANT PATIENT-DOCTOR UNION-MEMBER CHARITY-DONOR PROCESSOR and lots more.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
PartyAffiliationTypeCode (PK)	A unique retailer assigned code denoting the type of affiliation between two Partys.	CD_TYP_PRTY_AFLN	Code	varchar(20)
Description	A human readable description of the Party Affiliation reason.	DE_TYP_PRTY_AFLN	DescriptionShort	varchar(255)

Relationships

Parent Entity	Verb Phrase	Child Entity
PartyAffiliationType	categorizes	PartyAffiliation

Logical Views containing PartyAffiliationType

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended
Logical 07019 - Party-Consumer-Customer Household View
Logical 07030 - Customer Segment Independent Characteristics